SELECT id,titeldt,foto from viennawalks_walks WHERE (titeldt LIKE '% Werkbund%' or textdt LIKE '% Werkbund%' or keyword LIKE '% Werkbund%') AND id in (SELECT tour from viennawalks_termine where datum>='2024-04-29' group by tour) order by titeldt ASC